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