UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jmd0ApLr/ZJKi948qBbzdlmmwwPARkgrmB+X7Zo/AOc='
WHERE
key_id = '3ec4d8c20e4bc26380de61a7538945704bbd1486bf23369a38b1f159b387f0f6'
AND (
token = 'Jmd0ApLr/ZJKi948qBbzdlmmwwPARkgrmB+X7Zo/AOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)