UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3kZJyeMHrukCYJIaoUbvoCrdLiqTyyUYjCgF0lc7Mgk='
WHERE
key_id = '2a7d2e41a41003d0b47f0ade0d63eee950d7150ad6c5b589b9fff46356028e30'
AND (
token = '3kZJyeMHrukCYJIaoUbvoCrdLiqTyyUYjCgF0lc7Mgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)