UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KbFVPvOcYnykZwKg3X2+8wzCki/Ji/TGYgUo/EscKM='
WHERE
key_id = '9c3a562116af196a46c6a29ec36a4dac894f50d84f54581d92647ad25299ed31'
AND (
token = '7KbFVPvOcYnykZwKg3X2+8wzCki/Ji/TGYgUo/EscKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)