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