UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1AMQh2TO5Edk6xCZj4snNru0jaWVrJqUXl/XvO5hgs='
WHERE
key_id = '42578466da8052fc8493e2464592a7476ace8d6bbcb6c44ff864693ae7c7481b'
AND (
token = 'n1AMQh2TO5Edk6xCZj4snNru0jaWVrJqUXl/XvO5hgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)