UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5Zd3l2V8FlT+zQS1Dm7zmYfn9mqAoHTVtjw05+jKYQ='
WHERE
key_id = 'b6be0d84263c2c0d703e11620dd08f9035bbb65f7e57662b67f29a8038ca99df'
AND (
token = '/5Zd3l2V8FlT+zQS1Dm7zmYfn9mqAoHTVtjw05+jKYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)