UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'APB4JCecBnMTIoUg8LvJS7ln9oCcglIsZ2T2lucnRBA='
WHERE
key_id = 'b5a4da5b4aa725f5356677714b980fce143647d4459f4135bb5be67841eae70b'
AND (
token = 'APB4JCecBnMTIoUg8LvJS7ln9oCcglIsZ2T2lucnRBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)