UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wnbfua9pgvTvtFnJhOH1ec8kcipvIpYZyFbD0wnYdJ0='
WHERE
key_id = '06a3efab0bafeb5cf8a6f2a111814f5d94b839d7e9b2bb4cb2c7516f8fea5038'
AND (
token = 'Wnbfua9pgvTvtFnJhOH1ec8kcipvIpYZyFbD0wnYdJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)