UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gAlyoDshOc4702eueEaIxxxu8kdt4ugkbxyjWNvrz4k='
WHERE
key_id = '29a7b9bb46b6c53baa5ad2b4e8ee81ca6530c3e964006c7aca4fc0806d4702ca'
AND (
token = 'gAlyoDshOc4702eueEaIxxxu8kdt4ugkbxyjWNvrz4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)