UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqlsz7ke8bnKHF/H+2qQKwLl6s7Dyga34GCAyeGro7I='
WHERE
key_id = '5a0c15367314cedc9a4aa5678014b41000713863ef052a757a7bf54640fa7a15'
AND (
token = 'pqlsz7ke8bnKHF/H+2qQKwLl6s7Dyga34GCAyeGro7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)