UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vz7LJ3+f/rYqjmVbpdBVBEm01I59ES11FWCHiGfcMs8='
WHERE
key_id = 'aec8bb39fc1829ed134cd2eb42a7d66b1168891a0a5aa430eccf5738d9f82b14'
AND (
token = 'vz7LJ3+f/rYqjmVbpdBVBEm01I59ES11FWCHiGfcMs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)