UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CAZRuHZ6x+fluBnqjZP9Fx9X2MBhRzGg8ntxgQb63I='
WHERE
key_id = '75167e27234da084dba05914015c2989ded5929837a71b7b23e56428b2a56667'
AND (
token = '0CAZRuHZ6x+fluBnqjZP9Fx9X2MBhRzGg8ntxgQb63I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)