UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COs3UVwlFUjqSNQI+B7/5xQwB6K00+8T4Miv8LgrbyY='
WHERE
key_id = 'ccd7bde69c0a9afd9edc40ff3d7077f5b76b0ce29eed35ef0d9481ab82bd2df8'
AND (
token = 'COs3UVwlFUjqSNQI+B7/5xQwB6K00+8T4Miv8LgrbyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)