UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GCXq8os4zHp4Dc1/V4mszzccZg8aCG9JhX6Zdob5sH0='
WHERE
key_id = '4f55fec0d74a5c7959905a37170ca112ae48b25823f19d71990f7679115568b7'
AND (
token = 'GCXq8os4zHp4Dc1/V4mszzccZg8aCG9JhX6Zdob5sH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)