UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qDKxLKi/3ycE4SroBMVlOZbs5K18f5jaCTi3fXsZmTo='
WHERE
key_id = '20ffcd2f4245d994cefaea8ddc429003451f102dea16492fe065751b60f6f29f'
AND (
token = 'qDKxLKi/3ycE4SroBMVlOZbs5K18f5jaCTi3fXsZmTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)