UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mjej+VFE5HyftC2giMa8BzCzNCNovvOkR/sPo1cqTfU='
WHERE
key_id = '0c0a88bc116ee3934ac9d841713d253e666489d8275d744672fa5be1ce5696ef'
AND (
token = 'Mjej+VFE5HyftC2giMa8BzCzNCNovvOkR/sPo1cqTfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)