UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H1i/F5bbJOFZjUwGPpi+yZsHVwDNhBJxX8k0GkX7HL4='
WHERE
key_id = 'f4d5f2ecf93a343e68a06fc80a6fcb84b93068a6383634bb675b8aedd20ef899'
AND (
token = 'H1i/F5bbJOFZjUwGPpi+yZsHVwDNhBJxX8k0GkX7HL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)