UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aDY8WDQxGesgyu2Ssr0s3329vxZ/TVA0fFVYhmQhBXo='
WHERE
key_id = 'de20c7186af9b3747660e22fc8ad5a780811eae84dd4ed5d144d7d99d45d512c'
AND (
token = 'aDY8WDQxGesgyu2Ssr0s3329vxZ/TVA0fFVYhmQhBXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)