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