UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T/cZWBY5t4E4B+Pl29o87+ZqlrGW0cJi/0fbFagGjOw='
WHERE
key_id = 'fe720bb8738aad496971891000f2ae59c09678789a8096a0d9e147ac217da834'
AND (
token = 'T/cZWBY5t4E4B+Pl29o87+ZqlrGW0cJi/0fbFagGjOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)