UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUlqU9SKXcG9YgrFbJHu7j1lLDm230fzaIJzEixKITg='
WHERE
key_id = '550947ca353301d1e01f3d32b0596a5ed22f71fa283d3d2fc638c70902e315fd'
AND (
token = 'CUlqU9SKXcG9YgrFbJHu7j1lLDm230fzaIJzEixKITg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)