UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lc3ZDOQJgw6MDqlaekhphT0ZWeajZmE950VGuV6ivZA='
WHERE
key_id = '53196115e15c4bb73361d9fe37dd1bb6c76c282d5b58698bbceef6b89d00e4fc'
AND (
token = 'lc3ZDOQJgw6MDqlaekhphT0ZWeajZmE950VGuV6ivZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)