UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dFg1uWjlpZ/WmdFw9pA7dYOzxKk3XlTTNSToH78Virc='
WHERE
key_id = 'ddb5093fe123cedd5e83f2e1976f961b69435939b838dd4f0053fff7111a7657'
AND (
token = 'dFg1uWjlpZ/WmdFw9pA7dYOzxKk3XlTTNSToH78Virc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)