UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RsUZa+IGGRtcLs26ZANeo0x7e3W3ODF4X1mJotH1I2c='
WHERE
key_id = '4ab04df80d84a64fa3a4b0e043af8fbdd126bace000453391dfd714850ab5ee3'
AND (
token = 'RsUZa+IGGRtcLs26ZANeo0x7e3W3ODF4X1mJotH1I2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)