UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w4fU6z+bSP78uFiBjPsgdh7KcA1tvzTnrcBB5jGwIjk='
WHERE
key_id = '47edf12d7ee986eff27ea246e654b49caf54ff3f1c53a7ff917c5475df328fbb'
AND (
token = 'w4fU6z+bSP78uFiBjPsgdh7KcA1tvzTnrcBB5jGwIjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)