UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5b178rSsgSc9m9nkq2MzJrIOvv/d2M+/tMY3x3N1PY4='
WHERE
key_id = '24c721d40fcca9a0156a8db8fdf67cbb4b60cf3ef7c81f3444588e68ea474bb7'
AND (
token = '5b178rSsgSc9m9nkq2MzJrIOvv/d2M+/tMY3x3N1PY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)