UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ygp7icioeRtCnv9Irheg2A9f8kNI5yKObm19KgInK0='
WHERE
key_id = '2e7f6da5bd138f8ba23af5cecfaced2a38220a5aab286f4ab5b139f2fc2c02a6'
AND (
token = '+ygp7icioeRtCnv9Irheg2A9f8kNI5yKObm19KgInK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)