UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qg6kDE8uHPJ7mB9mreOl3NDgh6prOYKHhc9LrNAW3wk='
WHERE
key_id = 'fbadcab82cd55f2f49179c6188c4afe12dd1131cc7d334d13b76667edb7c79fe'
AND (
token = 'qg6kDE8uHPJ7mB9mreOl3NDgh6prOYKHhc9LrNAW3wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)