UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Z6BA2pviXwuvaOsZj9uZi7WkTDsChshKrhLDc54fy4='
WHERE
key_id = '21d177e8d2268c1e3fa8eb1188b1b893e8c002ed64c8ec447bc63e28a0c8356e'
AND (
token = '0Z6BA2pviXwuvaOsZj9uZi7WkTDsChshKrhLDc54fy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)