UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fDBQi6J7/tWhoMXUUjSe+3RWHOpwYSKQrEkU6g8gfHU='
WHERE
key_id = '5166b5fca3ec0ab92a8c121de9fccb2d54faf4bfdf55daebf117d763610bca78'
AND (
token = 'fDBQi6J7/tWhoMXUUjSe+3RWHOpwYSKQrEkU6g8gfHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)