UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kznfq5IdeOGABxSdtFYHChS757zaZiBZ44dZwtDNy0='
WHERE
key_id = '95d32047afe49d035306250389b4d56ac86a79f2fc9eb844044ab887ca980edd'
AND (
token = '0kznfq5IdeOGABxSdtFYHChS757zaZiBZ44dZwtDNy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)