UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCNFPapnw8NJBf0oWmibOaBaPCa3SUL2va1Fb+QKpE8='
WHERE
key_id = '56819c56c50a04810e5db0aa360cbe5eaf39d968025775a065b2db2b30e6900f'
AND (
token = 'SCNFPapnw8NJBf0oWmibOaBaPCa3SUL2va1Fb+QKpE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)