UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jd9J8BHvIkZrQ8zI7mNQI96JfY0QfmgYqlet2FN+s4o='
WHERE
key_id = '20adf8128ba64aadc314234152fc85498fcabda0497fc833010408a0b8bb3793'
AND (
token = 'Jd9J8BHvIkZrQ8zI7mNQI96JfY0QfmgYqlet2FN+s4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)